[dbo].[BAEEventSetupGetQuestions]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEEventSetupGetQuestions
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@eventCode
varchar(16)
16
SQL Script
create
procedure
[dbo]
.
[BAEEventSetupGetQuestions]
@eventCode
varchar
(
16
)
as
SELECT
*,
UPPER
(
FunctionCode
)
+
' '
+
Question
EventQuestion
FROM
EventSetupQuestion
WHERE
EventCode
=
@eventCode
ORDER
BY
QuestionOrder
GO
Uses
[dbo].[EventSetupQuestion]
dbo